create procedure [dbo].[BAEUpdateCreditCardStatus] @oNum decimal,
     @payTransDescription varchar(255) as
UPDATE    Trans
    SET        CC_STATUS = 'C', DESCRIPTION = @payTransDescription
    FROM        Trans trans
    WHERE    (SELECT    Orders.INVOICE_REFERENCE_NUM
              FROM        Orders Orders
              WHERE     @oNum = Orders.ORDER_NUMBER) = trans.INVOICE_REFERENCE_NUM AND
            trans.TRANSACTION_TYPE = 'PAY'

GO